package com.loukou.lkt.lkt.dao;

import java.util.List;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.loukou.lkt.lkt.entity.SupplierGoods;

public interface SupplierGoodsDao extends PagingAndSortingRepository<SupplierGoods, Integer>, JpaSpecificationExecutor<SupplierGoods> {

	Page<SupplierGoods> findBySupplierId(int id, Pageable pageable);
	
//	Page<SupplierGoods> findBySupplierIdAndTaosku(int supplierId, String taosku, Pageable pageable);
	
//	Page<SupplierGoods> findBySupplierIdAndBn(int supplierId,String bn, Pageable pageable);
//	List<Supplier> findBySupplierCodeLikeAndSupplierNameLike(String supplierCode, String supplierName);
//	
//	List<Supplier> findBySupplierCodeAndSupplierNameLike(String supplierCode, String supplierName);
//
//	Supplier findBySupplierCode(String supplierCode);
//	
//	Supplier findById(int id);
//	
//	List<Supplier> findBySupplierNameLike(String supplierName);
//
//	@Query("SELECT s FROM Supplier s WHERE isUse =?1 AND isExamine = ?2")
//	Page<Supplier> findByIsUseAndIsExamine(int isUse, int isExamine, Pageable Pageable);
	
	List<SupplierGoods> findBySupplierId(int id);
	
	List<SupplierGoods> findBySupplierIdAndGoodsIdIn(int id,List<Integer> goodsIds);
	
	
}
